CREATE TABLE [dbo].[Zip_Code]
(
[ZIP] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Zip_Code_ZIP] DEFAULT (''),
[CITY] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Zip_Code_CITY] DEFAULT (''),
[STATE] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Zip_Code_STATE] DEFAULT (''),
[ZIP_TYPE] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Zip_Code_ZIP_TYPE] DEFAULT (''),
[COUNTY_FIPS] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Zip_Code_COUNTY_FIPS] DEFAULT (''),
[COUNTY] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Zip_Code_COUNTY] DEFAULT (''),
[AREA_CODE] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Zip_Code_AREA_CODE] DEFAULT (''),
[CHAPTER] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Zip_Code_CHAPTER] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Zip_Code] ADD CONSTRAINT [PK_Zip_Code] PRIMARY KEY CLUSTERED ([ZIP]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Zip_Code] TO [IMIS]
GRANT SELECT ON  [dbo].[Zip_Code] TO [IMIS]
GRANT INSERT ON  [dbo].[Zip_Code] TO [IMIS]
GRANT DELETE ON  [dbo].[Zip_Code] TO [IMIS]
GRANT UPDATE ON  [dbo].[Zip_Code] TO [IMIS]
GO